--SELECT * FROM ReciveResume
--DELETE FROM ReciveResume
--INSERT INTO srv_lnk.nchr2008.dbo.ReciveResume
SELECT top 5
Convert(int,right(id,7)) AS [ID],Convert(int,right(companyid,7)) AS [CompanyID],Convert(int,right(resumeid,7)) AS [ResumeID],'Chinese' AS [strLanguage],Convert(int,right(jobid,7)) AS [JobID],1 AS [RepplyFlag],0 AS [ViewFlag],0 AS [introFlag],[CoverLetter] AS [JobLetterContent],0 AS [applycount],Convert(int,right(jobseekerid,7)) AS [CreatedUserId],[DateApplied] AS [CreatedDate],Convert(int,right(jobseekerid,7)) AS [UpdatedUserId],[DateApplied] AS [UpdatedDate]FROM Forest.dbo.cat_application
SELECT TOP 5 * FROM Forest.dbo.cat_application
select top 5 * from srv_lnk.nchr2008.dbo.ReciveResume
